7 of 14
For this step you'll need full access to the ColdFusion
Administrator application on each server in the cluster. Here's what
to do in detail:
a. Start the ColdFusion Administrator (usually found
by clicking Start | Programs | ColdFusion Server 4.x | ColdFusion
Administrator).
b. Log in using the password for
administrator access that you chose when CF Server was installed.
c. Click on ODBC under the Data Sources section on
the left sidebar.
d. Type the data source name
("CVR" in this example), choose the ODBC Driver ("Microsoft SQL
Server Driver" in this example) and click the Add button.
e. Enter the name or IP address of the database
server in the Server field.
f. In the database
field enter the name of the database you created in Step 1 ("CVR" in
this example).
g. Click the CF Settings button and
complete the username and password fields to access this database.
h. Make sure Maintain Database Connections is
checked.
i. Click the Create button. After the data
source is created you should see your list of data sources again,
with "verified" next to the data source you just created. If you
don't see "verified," you must take whatever steps are necessary
until this server is able to connect to the data source. The
connection must be verified before you can continue.
2.2: Configure client variable storage.
Now that you've created the data source, you will configure the
server(s) to use that data source to store client variables.Here's
how to do so in detail:
a. Under the Server category in the left sidebar,
click Variables.
b. You will see a select box at
the top, under Name. Choose the data source you created above ("CVR"
in this example) from the select box, and click Add.
c. On the page that loads next, choose the number
of days you wish to have client variables stored in your database.
The default is 10 days.
d. For higher-traffic
sites, you may wish to select Disable Global Client Variable
Updates. In the beginning, try leaving them enabled; if performance
suffers, you can place a check in this box later. Keep in mind that
if you write code that depends upon the automatic updating of such
client variables as "LVISIT" (the last date/time the client with
that CFID loaded a page) and "HITCOUNT" (the number of page
impressions by a particular client), your code will break if you
disable global updates later.
7 of 14